import datetime
from applications.extensions import db

#体征设备
class Signequip(db.Model):
    __tablename__ = 'admin_sign_equip'
    id = db.Column(db.Integer, primary_key=True, autoincrement=True, comment='id')
    code = db.Column(db.String(20), comment='设备编号')
    sn = db.Column(db.String(20), comment='设备sn码')
    name = db.Column(db.String(20), comment='设备名称')
    remark = db.Column(db.String(20), comment='备注')
    dept_id = db.Column(db.Integer, comment='所属部门id')
    dept_parent_name = db.Column(db.String(20), comment='所属部门')
    dept_name = db.Column(db.String(20), comment='所属部门')